package com.wyp.service;

import com.wyp.pojo.Scores;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface ScoresService {
    //返回所有成绩信息给前端页面
    public List<Map<String,Object>> qureyAllScores();

    //查询成绩信息
    public Scores qureyScoresByRepeat(@Param("stuid") int stuid, @Param("testpaperid") int testpaperid);
    public List<Map<String,Object>> qureyScoresByStuid(int stuid);
    public List<Map<String,Object>> qureyScoresByReach(int stuid);
    public List<Map<String,Object>> qureyScoresByStuTest(@Param("stuid") int stuid, @Param("testpapername") String testpapername);
    public Map<String,Object> qureyScoresByScoresid(int scoid);
    public List<Map<String,Object>> qureyScoresByStuname(String stuname);
    public List<Map<String,Object>> qureyScoresByPapername(String testpapername);

    //添加成绩
    public boolean addScores(Scores scores);

    //更新成绩信息
    public boolean updateScores(Scores scores);

    //删除成绩信息
    public boolean deleteScores(Integer id);
}
